Pandas Profiling Report

Dataset statistics

Number of variables	15
Number of observations	170653
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	705
Duplicate rows (%)	0.4%
Total size in memory	19.5 MiB
Average record size in memory	120.0 B

Variable types

Numeric	13
Categorical	2

Alerts

Dataset has 705 (0.4%) duplicate rows	Duplicates
`acousticness` is highly overall correlated with `energy` and 3 other fields	High correlation
`danceability` is highly overall correlated with `valence`	High correlation
`energy` is highly overall correlated with `acousticness` and 2 other fields	High correlation
`loudness` is highly overall correlated with `acousticness` and 3 other fields	High correlation
`popularity` is highly overall correlated with `acousticness` and 2 other fields	High correlation
`valence` is highly overall correlated with `danceability`	High correlation
`year` is highly overall correlated with `acousticness` and 3 other fields	High correlation
`explicit` is highly imbalanced (58.2%)	Imbalance
`instrumentalness` has 46580 (27.3%) zeros	Zeros
`voice_pitch` has 21600 (12.7%) zeros	Zeros
`popularity` has 27892 (16.3%) zeros	Zeros

Reproduction

Analysis started	2024-01-20 10:38:28.078762
Analysis finished	2024-01-20 10:40:00.841891
Duration	1 minute and 32.76 seconds
Software version	ydata-profiling vv4.6.4
Download configuration	config.json

year
Real number (ℝ)

HIGH CORRELATION

Distinct	100
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1976.7872

Minimum	1921
Maximum	2020
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.3 MiB

Quantile statistics

Minimum	1921
5-th percentile	1933
Q1	1956
median	1977
Q3	1999
95-th percentile	2016
Maximum	2020
Range	99
Interquartile range (IQR)	43

Descriptive statistics

Standard deviation	25.917853
Coefficient of variation (CV)	0.013111099
Kurtosis	-1.0355084
Mean	1976.7872
Median Absolute Deviation (MAD)	22
Skewness	-0.12943464
Sum	3.3734467 × 10⁸
Variance	671.73508
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2018	2103	1.2%
2020	2030	1.2%
2011	2017	1.2%
2010	2016	1.2%
2014	2005	1.2%
2001	2005	1.2%
1974	2000	1.2%
1979	2000	1.2%
1978	2000	1.2%
1977	2000	1.2%
Other values (90)	150477	88.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1921	150	0.1%
1922	71	< 0.1%
1923	185	0.1%
1924	236	0.1%
1925	278	0.2%
1926	1378	0.8%
1927	615	0.4%
1928	1261	0.7%
1929	952	0.6%
1930	1924	1.1%

Value	Count	Frequency (%)
2020	2030	1.2%
2019	1949	1.1%
2018	2103	1.2%
2017	1992	1.2%
2016	1797	1.1%
2015	1974	1.2%
2014	2005	1.2%
2013	1976	1.2%
2012	1945	1.1%
2011	2017	1.2%

duration_ms
Real number (ℝ)

Distinct	51755
Distinct (%)	30.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	230948.31

Minimum	5108
Maximum	5403500
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.3 MiB

Quantile statistics

Minimum	5108
5-th percentile	110987
Q1	169827
median	207467
Q3	262400
95-th percentile	411551.6
Maximum	5403500
Range	5398392
Interquartile range (IQR)	92573

Descriptive statistics

Standard deviation	126118.41
Coefficient of variation (CV)	0.54608936
Kurtosis	132.92182
Mean	230948.31
Median Absolute Deviation (MAD)	44467
Skewness	7.3137407
Sum	3.9412022 × 10¹⁰
Variance	1.5905855 × 10¹⁰
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
192000	56	< 0.1%
170000	50	< 0.1%
180000	49	< 0.1%
186000	49	< 0.1%
184000	48	< 0.1%
160000	48	< 0.1%
168000	46	< 0.1%
240000	46	< 0.1%
195000	45	< 0.1%
175000	44	< 0.1%
Other values (51745)	170172	99.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
5108	1	< 0.1%
5991	1	< 0.1%
6362	1	< 0.1%
6467	1	< 0.1%
8853	2	< 0.1%
9680	1	< 0.1%
10371	1	< 0.1%
11973	1	< 0.1%
13453	1	< 0.1%
13600	1	< 0.1%

Value	Count	Frequency (%)
5403500	1	< 0.1%
4270034	1	< 0.1%
4269407	1	< 0.1%
4120258	2	< 0.1%
3816373	1	< 0.1%
3650800	1	< 0.1%
3569933	1	< 0.1%
3557955	1	< 0.1%
3556867	1	< 0.1%
3551152	1	< 0.1%

acousticness
Real number (ℝ)

HIGH CORRELATION

Distinct	4689
Distinct (%)	2.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.50211476

Minimum	0
Maximum	0.996
Zeros	20
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	1.3 MiB

Quantile statistics

Minimum	0
5-th percentile	0.00147
Q1	0.102
median	0.516
Q3	0.893
95-th percentile	0.992
Maximum	0.996
Range	0.996
Interquartile range (IQR)	0.791

Descriptive statistics

Standard deviation	0.37603173
Coefficient of variation (CV)	0.74889597
Kurtosis	-1.6094281
Mean	0.50211476
Median Absolute Deviation (MAD)	0.395
Skewness	-0.032582418
Sum	85687.391
Variance	0.14139986
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.995	3117	1.8%
0.994	2323	1.4%
0.993	1759	1.0%
0.992	1513	0.9%
0.991	1298	0.8%
0.99	1180	0.7%
0.996	1058	0.6%
0.989	1053	0.6%
0.988	927	0.5%
0.987	818	0.5%
Other values (4679)	155607	91.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	20	< 0.1%
1 × 10^-6	1	< 0.1%
1.01 × 10^-6	3	< 0.1%
1.02 × 10^-6	1	< 0.1%
1.03 × 10^-6	1	< 0.1%
1.05 × 10^-6	2	< 0.1%
1.07 × 10^-6	1	< 0.1%
1.11 × 10^-6	1	< 0.1%
1.15 × 10^-6	1	< 0.1%
1.17 × 10^-6	2	< 0.1%

Value	Count	Frequency (%)
0.996	1058	0.6%
0.995	3117	1.8%
0.994	2323	1.4%
0.993	1759	1.0%
0.992	1513	0.9%
0.991	1298	0.8%
0.99	1180	0.7%
0.989	1053	0.6%
0.988	927	0.5%
0.987	818	0.5%

danceability
Real number (ℝ)

HIGH CORRELATION

Distinct	1240
Distinct (%)	0.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.53739553

Minimum	0
Maximum	0.988
Zeros	143
Zeros (%)	0.1%
Negative	0
Negative (%)	0.0%
Memory size	1.3 MiB

Quantile statistics

Minimum	0
5-th percentile	0.23
Q1	0.415
median	0.548
Q3	0.668
95-th percentile	0.811
Maximum	0.988
Range	0.988
Interquartile range (IQR)	0.253

Descriptive statistics

Standard deviation	0.17613774
Coefficient of variation (CV)	0.32776181
Kurtosis	-0.44289742
Mean	0.53739553
Median Absolute Deviation (MAD)	0.126
Skewness	-0.22347135
Sum	91708.16
Variance	0.031024502
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.565	430	0.3%
0.612	408	0.2%
0.632	402	0.2%
0.61	401	0.2%
0.578	399	0.2%
0.559	398	0.2%
0.545	397	0.2%
0.6	395	0.2%
0.548	394	0.2%
0.556	393	0.2%
Other values (1230)	166636	97.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	143	0.1%
0.0551	1	< 0.1%
0.0559	2	< 0.1%
0.0569	2	< 0.1%
0.0574	1	< 0.1%
0.0583	1	< 0.1%
0.0587	1	< 0.1%
0.0589	1	< 0.1%
0.059	1	< 0.1%
0.0591	1	< 0.1%

Value	Count	Frequency (%)
0.988	1	< 0.1%
0.986	2	< 0.1%
0.985	1	< 0.1%
0.983	1	< 0.1%
0.98	4	< 0.1%
0.979	3	< 0.1%
0.978	3	< 0.1%
0.977	5	< 0.1%
0.976	1	< 0.1%
0.975	6	< 0.1%

liveness
Real number (ℝ)

Distinct	1740
Distinct (%)	1.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.20583866

Minimum	0
Maximum	1
Zeros	12
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	1.3 MiB

Quantile statistics

Minimum	0
5-th percentile	0.0599
Q1	0.0988
median	0.136
Q3	0.261
95-th percentile	0.61
Maximum	1
Range	1
Interquartile range (IQR)	0.1622

Descriptive statistics

Standard deviation	0.17480466
Coefficient of variation (CV)	0.84923146
Kurtosis	5.0012722
Mean	0.20583866
Median Absolute Deviation (MAD)	0.0532
Skewness	2.1543815
Sum	35126.984
Variance	0.03055667
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.111	1849	1.1%
0.11	1663	1.0%
0.109	1636	1.0%
0.108	1624	1.0%
0.107	1553	0.9%
0.106	1508	0.9%
0.112	1500	0.9%
0.105	1481	0.9%
0.103	1402	0.8%
0.114	1379	0.8%
Other values (1730)	155058	90.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	12	< 0.1%
0.00967	1	< 0.1%
0.0101	1	< 0.1%
0.0103	1	< 0.1%
0.0116	1	< 0.1%
0.012	1	< 0.1%
0.0123	1	< 0.1%
0.0134	1	< 0.1%
0.0136	3	< 0.1%
0.0139	1	< 0.1%

Value	Count	Frequency (%)
1	1	< 0.1%
0.999	1	< 0.1%
0.998	2	< 0.1%
0.997	5	< 0.1%
0.996	3	< 0.1%
0.995	10	< 0.1%
0.994	8	< 0.1%
0.993	5	< 0.1%
0.992	13	< 0.1%
0.991	16	< 0.1%

loudness
Real number (ℝ)

HIGH CORRELATION

Distinct	25410
Distinct (%)	14.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	-11.46799

Minimum	-60
Maximum	3.855
Zeros	0
Zeros (%)	0.0%
Negative	170622
Negative (%)	> 99.9%
Memory size	1.3 MiB

Quantile statistics

Minimum	-60
5-th percentile	-22.02
Q1	-14.615
median	-10.58
Q3	-7.183
95-th percentile	-4.1306
Maximum	3.855
Range	63.855
Interquartile range (IQR)	7.432

Descriptive statistics

Standard deviation	5.6979429
Coefficient of variation (CV)	-0.49685628
Kurtosis	1.8468035
Mean	-11.46799
Median Absolute Deviation (MAD)	3.648
Skewness	-1.0518411
Sum	-1957046.9
Variance	32.466553
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
-6.942	27	< 0.1%
-7.436	27	< 0.1%
-6.664	26	< 0.1%
-8.32	26	< 0.1%
-11.815	25	< 0.1%
-7.566	25	< 0.1%
-7.632	25	< 0.1%
-8.992	25	< 0.1%
-9.298	24	< 0.1%
-7.02	24	< 0.1%
Other values (25400)	170399	99.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-60	9	< 0.1%
-55	1	< 0.1%
-54.837	1	< 0.1%
-54.376	1	< 0.1%
-52.22	1	< 0.1%
-51.123	1	< 0.1%
-51.08	1	< 0.1%
-50.174	1	< 0.1%
-48.587	1	< 0.1%
-48.278	2	< 0.1%

Value	Count	Frequency (%)
3.855	1	< 0.1%
3.744	1	< 0.1%
2.799	1	< 0.1%
1.963	1	< 0.1%
1.83	1	< 0.1%
1.483	1	< 0.1%
1.342	1	< 0.1%
1.275	1	< 0.1%
1.073	1	< 0.1%
1.023	1	< 0.1%

energy
Real number (ℝ)

HIGH CORRELATION

Distinct	2332
Distinct (%)	1.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.48238884

Minimum	0
Maximum	1
Zeros	9
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	1.3 MiB

Quantile statistics

Minimum	0
5-th percentile	0.076
Q1	0.255
median	0.471
Q3	0.703
95-th percentile	0.924
Maximum	1
Range	1
Interquartile range (IQR)	0.448

Descriptive statistics

Standard deviation	0.2676457
Coefficient of variation (CV)	0.55483395
Kurtosis	-1.1001327
Mean	0.48238884
Median Absolute Deviation (MAD)	0.224
Skewness	0.11203494
Sum	82321.102
Variance	0.071634223
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.2	247	0.1%
0.341	244	0.1%
0.187	242	0.1%
0.255	241	0.1%
0.219	239	0.1%
0.274	238	0.1%
0.185	238	0.1%
0.32	237	0.1%
0.245	237	0.1%
0.306	237	0.1%
Other values (2322)	168253	98.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	9	< 0.1%
1.99 × 10^-5	1	< 0.1%
2 × 10^-5	1	< 0.1%
2.01 × 10^-5	7	< 0.1%
2.02 × 10^-5	3	< 0.1%
2.03 × 10^-5	10	< 0.1%
2.8 × 10^-5	1	< 0.1%
3.22 × 10^-5	1	< 0.1%
4.28 × 10^-5	1	< 0.1%
4.98 × 10^-5	1	< 0.1%

Value	Count	Frequency (%)
1	21	< 0.1%
0.999	28	< 0.1%
0.998	38	< 0.1%
0.997	51	< 0.1%
0.996	64	< 0.1%
0.995	81	< 0.1%
0.994	76	< 0.1%
0.993	73	< 0.1%
0.992	59	< 0.1%
0.991	88	0.1%

instrumentalness
Real number (ℝ)

ZEROS

Distinct	5401
Distinct (%)	3.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.16700958

Minimum	0
Maximum	1
Zeros	46580
Zeros (%)	27.3%
Negative	0
Negative (%)	0.0%
Memory size	1.3 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0.000216
Q3	0.102
95-th percentile	0.905
Maximum	1
Range	1
Interquartile range (IQR)	0.102

Descriptive statistics

Standard deviation	0.31347467
Coefficient of variation (CV)	1.8769862
Kurtosis	0.94219542
Mean	0.16700958
Median Absolute Deviation (MAD)	0.000216
Skewness	1.631114
Sum	28500.686
Variance	0.098266371
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	46580	27.3%
0.916	201	0.1%
0.917	197	0.1%
0.904	191	0.1%
0.922	191	0.1%
0.913	188	0.1%
0.911	186	0.1%
0.899	185	0.1%
0.909	185	0.1%
0.914	184	0.1%
Other values (5391)	122365	71.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	46580	27.3%
1 × 10^-6	24	< 0.1%
1.01 × 10^-6	67	< 0.1%
1.02 × 10^-6	84	< 0.1%
1.03 × 10^-6	69	< 0.1%
1.04 × 10^-6	56	< 0.1%
1.05 × 10^-6	58	< 0.1%
1.06 × 10^-6	57	< 0.1%
1.07 × 10^-6	67	< 0.1%
1.08 × 10^-6	55	< 0.1%

Value	Count	Frequency (%)
1	10	< 0.1%
0.999	12	< 0.1%
0.998	9	< 0.1%
0.997	4	< 0.1%
0.996	6	< 0.1%
0.995	6	< 0.1%
0.994	8	< 0.1%
0.993	16	< 0.1%
0.992	11	< 0.1%
0.991	6	< 0.1%

bpm
Real number (ℝ)

Distinct	84694
Distinct (%)	49.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	116.86159

Minimum	0
Maximum	243.507
Zeros	143
Zeros (%)	0.1%
Negative	0
Negative (%)	0.0%
Memory size	1.3 MiB

Quantile statistics

Minimum	0
5-th percentile	74.1516
Q1	93.421
median	114.729
Q3	135.537
95-th percentile	174.3738
Maximum	243.507
Range	243.507
Interquartile range (IQR)	42.116

Descriptive statistics

Standard deviation	30.708533
Coefficient of variation (CV)	0.26277696
Kurtosis	-0.077953213
Mean	116.86159
Median Absolute Deviation (MAD)	21.091
Skewness	0.44974062
Sum	19942781
Variance	943.014
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	143	0.1%
120	20	< 0.1%
120.012	20	< 0.1%
94.997	19	< 0.1%
128.005	19	< 0.1%
120.011	18	< 0.1%
119.994	17	< 0.1%
129.995	16	< 0.1%
119.969	16	< 0.1%
90.001	16	< 0.1%
Other values (84684)	170349	99.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	143	0.1%
30.946	1	< 0.1%
31.988	1	< 0.1%
32.466	1	< 0.1%
32.8	1	< 0.1%
32.941	1	< 0.1%
33.334	1	< 0.1%
33.391	1	< 0.1%
33.944	1	< 0.1%
34.496	1	< 0.1%

Value	Count	Frequency (%)
243.507	1	< 0.1%
243.372	1	< 0.1%
238.895	1	< 0.1%
236.799	1	< 0.1%
224.437	1	< 0.1%
222.605	1	< 0.1%
221.741	1	< 0.1%
221.112	1	< 0.1%
221.058	2	< 0.1%
220.229	1	< 0.1%

speechiness
Real number (ℝ)

Distinct	1626
Distinct (%)	1.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.098393262

Minimum	0
Maximum	0.97
Zeros	143
Zeros (%)	0.1%
Negative	0
Negative (%)	0.0%
Memory size	1.3 MiB

Quantile statistics

Minimum	0
5-th percentile	0.0281
Q1	0.0349
median	0.045
Q3	0.0756
95-th percentile	0.354
Maximum	0.97
Range	0.97
Interquartile range (IQR)	0.0407

Descriptive statistics

Standard deviation	0.16274007
Coefficient of variation (CV)	1.6539758
Kurtosis	17.000433
Mean	0.098393262
Median Absolute Deviation (MAD)	0.0131
Skewness	4.0478485
Sum	16791.105
Variance	0.026484331
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.0347	580	0.3%
0.0334	571	0.3%
0.0328	563	0.3%
0.0337	561	0.3%
0.033	559	0.3%
0.0332	557	0.3%
0.0349	557	0.3%
0.0363	553	0.3%
0.0362	553	0.3%
0.0344	552	0.3%
Other values (1616)	165047	96.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	143	0.1%
0.0222	1	< 0.1%
0.0223	3	< 0.1%
0.0224	5	< 0.1%
0.0225	4	< 0.1%
0.0226	5	< 0.1%
0.0227	7	< 0.1%
0.0228	9	< 0.1%
0.0229	7	< 0.1%
0.023	9	< 0.1%

Value	Count	Frequency (%)
0.97	1	< 0.1%
0.969	3	< 0.1%
0.968	5	< 0.1%
0.967	12	< 0.1%
0.966	27	< 0.1%
0.965	34	< 0.1%
0.964	56	< 0.1%
0.963	73	< 0.1%
0.962	81	< 0.1%
0.961	106	0.1%

has_lyrics
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.3 MiB

1	120635
0	50018

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	170653
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	1
2nd row	1
3rd row	1
4th row	1
5th row	1

Common Values

Value	Count	Frequency (%)
1	120635	70.7%
0	50018	29.3%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
1	120635	70.7%
0	50018	29.3%

Most occurring characters

Value	Count	Frequency (%)
1	120635	70.7%
0	50018	29.3%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	170653	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
1	120635	70.7%
0	50018	29.3%

Most occurring scripts

Value	Count	Frequency (%)
Common	170653	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
1	120635	70.7%
0	50018	29.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	170653	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
1	120635	70.7%
0	50018	29.3%

explicit
Categorical

IMBALANCE

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.3 MiB

0	156220
1	14433

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	170653
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	0
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	156220	91.5%
1	14433	8.5%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0	156220	91.5%
1	14433	8.5%

Most occurring characters

Value	Count	Frequency (%)
0	156220	91.5%
1	14433	8.5%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	170653	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	156220	91.5%
1	14433	8.5%

Most occurring scripts

Value	Count	Frequency (%)
Common	170653	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	156220	91.5%
1	14433	8.5%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	170653	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	156220	91.5%
1	14433	8.5%

valence
Real number (ℝ)

HIGH CORRELATION

Distinct	1733
Distinct (%)	1.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.52858721

Minimum	0
Maximum	1
Zeros	196
Zeros (%)	0.1%
Negative	0
Negative (%)	0.0%
Memory size	1.3 MiB

Quantile statistics

Minimum	0
5-th percentile	0.0905
Q1	0.317
median	0.54
Q3	0.747
95-th percentile	0.937
Maximum	1
Range	1
Interquartile range (IQR)	0.43

Descriptive statistics

Standard deviation	0.26317146
Coefficient of variation (CV)	0.49787709
Kurtosis	-1.0616275
Mean	0.52858721
Median Absolute Deviation (MAD)	0.215
Skewness	-0.10711976
Sum	90204.993
Variance	0.069259219
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.961	718	0.4%
0.962	593	0.3%
0.963	515	0.3%
0.964	462	0.3%
0.965	400	0.2%
0.96	388	0.2%
0.966	349	0.2%
0.967	316	0.2%
0.968	269	0.2%
0.559	248	0.1%
Other values (1723)	166395	97.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	196	0.1%
1 × 10^-5	70	< 0.1%
6.41 × 10^-5	1	< 0.1%
0.000537	1	< 0.1%
0.000562	1	< 0.1%
0.00126	1	< 0.1%
0.00166	1	< 0.1%
0.00173	1	< 0.1%
0.00213	1	< 0.1%
0.00228	1	< 0.1%

Value	Count	Frequency (%)
1	4	< 0.1%
0.998	1	< 0.1%
0.996	2	< 0.1%
0.995	1	< 0.1%
0.994	3	< 0.1%
0.993	4	< 0.1%
0.991	4	< 0.1%
0.99	8	< 0.1%
0.989	6	< 0.1%
0.988	7	< 0.1%

voice_pitch
Real number (ℝ)

ZEROS

Distinct	12
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	5.1998441

Minimum	0
Maximum	11
Zeros	21600
Zeros (%)	12.7%
Negative	0
Negative (%)	0.0%
Memory size	1.3 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	2
median	5
Q3	8
95-th percentile	11
Maximum	11
Range	11
Interquartile range (IQR)	6

Descriptive statistics

Standard deviation	3.5150939
Coefficient of variation (CV)	0.67599986
Kurtosis	-1.2710487
Mean	5.1998441
Median Absolute Deviation (MAD)	3
Skewness	0.0058639886
Sum	887369
Variance	12.355885
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=12)

Value	Count	Frequency (%)
0	21600	12.7%
7	20803	12.2%
2	18823	11.0%
9	17571	10.3%
5	16430	9.6%
4	12933	7.6%
1	12886	7.6%
10	12148	7.1%
8	10751	6.3%
11	10670	6.3%
Other values (2)	16038	9.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	21600	12.7%
1	12886	7.6%
2	18823	11.0%
3	7297	4.3%
4	12933	7.6%
5	16430	9.6%
6	8741	5.1%
7	20803	12.2%
8	10751	6.3%
9	17571	10.3%

Value	Count	Frequency (%)
11	10670	6.3%
10	12148	7.1%
9	17571	10.3%
8	10751	6.3%
7	20803	12.2%
6	8741	5.1%
5	16430	9.6%
4	12933	7.6%
3	7297	4.3%
2	18823	11.0%

popularity
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	100
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	31.431794

Minimum	0
Maximum	100
Zeros	27892
Zeros (%)	16.3%
Negative	0
Negative (%)	0.0%
Memory size	1.3 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	11
median	33
Q3	48
95-th percentile	66
Maximum	100
Range	100
Interquartile range (IQR)	37

Descriptive statistics

Standard deviation	21.826615
Coefficient of variation (CV)	0.694412
Kurtosis	-1.025591
Mean	31.431794
Median Absolute Deviation (MAD)	17
Skewness	-0.003733875
Sum	5363930
Variance	476.40113
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	27892	16.3%
43	3136	1.8%
44	3117	1.8%
41	3078	1.8%
42	3051	1.8%
40	3051	1.8%
39	2968	1.7%
36	2896	1.7%
46	2883	1.7%
1	2876	1.7%
Other values (90)	115705	67.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	27892	16.3%
1	2876	1.7%
2	1733	1.0%
3	1467	0.9%
4	1114	0.7%
5	1018	0.6%
6	1017	0.6%
7	1116	0.7%
8	1128	0.7%
9	1213	0.7%

Value	Count	Frequency (%)
100	1	< 0.1%
99	1	< 0.1%
97	1	< 0.1%
96	4	< 0.1%
95	4	< 0.1%
94	4	< 0.1%
93	4	< 0.1%
92	11	< 0.1%
91	9	< 0.1%
90	11	< 0.1%

Auto

Heatmap
Table

	acousticness	bpm	danceability	duration_ms	energy	explicit	has_lyrics	instrumentalness	liveness	loudness	popularity	speechiness	valence	voice_pitch	year
acousticness	1.000	-0.231	-0.230	-0.233	-0.759	0.249	0.061	0.292	0.017	-0.600	-0.574	-0.055	-0.158	-0.018	-0.626
bpm	-0.231	1.000	0.022	0.013	0.263	0.078	0.016	-0.078	-0.005	0.209	0.138	0.080	0.172	0.002	0.149
danceability	-0.230	0.022	1.000	-0.088	0.217	0.283	0.062	-0.281	-0.116	0.233	0.194	0.239	0.540	0.023	0.195
duration_ms	-0.233	0.013	-0.088	1.000	0.177	0.034	0.016	0.106	-0.066	0.125	0.231	-0.094	-0.199	-0.003	0.259
energy	-0.759	0.263	0.217	0.177	1.000	0.155	0.048	-0.221	0.067	0.814	0.487	0.124	0.359	0.027	0.537
explicit	0.249	0.078	0.283	0.034	0.155	1.000	0.079	-0.233	0.054	0.167	0.191	0.343	-0.023	0.005	0.231
has_lyrics	0.061	0.016	0.062	0.016	0.048	0.079	1.000	-0.042	0.002	-0.023	-0.030	-0.104	0.015	-0.115	-0.035
instrumentalness	0.292	-0.078	-0.281	0.106	-0.221	-0.233	-0.042	1.000	-0.053	-0.339	-0.297	-0.101	-0.167	-0.012	-0.288
liveness	0.017	-0.005	-0.116	-0.066	0.067	0.054	0.002	-0.053	1.000	0.030	-0.114	0.112	-0.010	-0.003	-0.102
loudness	-0.600	0.209	0.233	0.125	0.814	0.167	-0.023	-0.339	0.030	1.000	0.505	0.048	0.263	0.019	0.553
popularity	-0.574	0.138	0.194	0.231	0.487	0.191	-0.030	-0.297	-0.114	0.505	1.000	-0.090	0.006	0.008	0.863
speechiness	-0.055	0.080	0.239	-0.094	0.124	0.343	-0.104	-0.101	0.112	0.048	-0.090	1.000	0.143	0.033	-0.048
valence	-0.158	0.172	0.540	-0.199	0.359	-0.023	0.015	-0.167	-0.010	0.263	0.006	0.143	1.000	0.028	-0.030
voice_pitch	-0.018	0.002	0.023	-0.003	0.027	0.005	-0.115	-0.012	-0.003	0.019	0.008	0.033	0.028	1.000	0.008
year	-0.626	0.149	0.195	0.259	0.537	0.231	-0.035	-0.288	-0.102	0.553	0.863	-0.048	-0.030	0.008	1.000

Count
Matrix

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

First rows
Last rows

	year	duration_ms	acousticness	danceability	liveness	loudness	energy	instrumentalness	bpm	speechiness	has_lyrics	valence	voice_pitch	popularity
0	1921	831667	0.982	0.279	0.665	-20.096	0.211	0.878000	80.954	0.0366	1	0.0594	10	4
1	1921	180533	0.732	0.819	0.160	-12.441	0.341	0.000000	60.936	0.4150	1	0.9630	7	5
2	1921	500062	0.961	0.328	0.101	-14.850	0.166	0.913000	110.339	0.0339	1	0.0394	3	5
3	1921	210000	0.967	0.275	0.381	-9.316	0.309	0.000028	100.109	0.0354	1	0.1650	5	3
4	1921	166693	0.957	0.418	0.229	-10.096	0.193	0.000002	101.665	0.0380	1	0.2530	3	2
5	1921	395076	0.579	0.697	0.130	-12.506	0.346	0.168000	119.824	0.0700	1	0.1960	2	6
6	1921	159507	0.996	0.518	0.115	-10.589	0.203	0.000000	66.221	0.0615	1	0.4060	0	4
7	1921	218773	0.993	0.389	0.363	-21.091	0.088	0.527000	92.867	0.0456	0	0.0731	1	2
8	1921	161520	0.996	0.485	0.104	-21.508	0.130	0.151000	64.678	0.0483	0	0.7210	5	0
9	1921	196560	0.982	0.684	0.504	-16.415	0.257	0.000000	109.378	0.3990	1	0.7710	8	0

	year	duration_ms	acousticness	danceability	liveness	loudness	energy	instrumentalness	bpm	speechiness	has_lyrics	explicit	valence	voice_pitch	popularity
170643	2020	228333	0.00952	0.917	0.0774	-10.456	0.56900	0.000000	144.014	0.2790	1	1	0.9070	7	66
170644	2020	253613	0.31000	0.562	0.1250	-8.480	0.68600	0.022500	103.054	0.0249	1	0	0.4660	7	66
170645	2020	190500	0.99400	0.281	0.0995	-31.460	0.03330	0.959000	90.250	0.0348	1	0	0.1690	6	70
170646	2020	230600	0.20400	0.598	0.1080	-10.991	0.47200	0.000015	120.080	0.2580	1	1	0.5220	0	66
170647	2020	133500	0.97400	0.175	0.1130	-35.072	0.00759	0.925000	70.872	0.0454	1	0	0.0838	7	70
170648	2020	301714	0.08460	0.786	0.0822	-3.702	0.80800	0.000289	105.029	0.0881	1	0	0.6080	7	72
170649	2020	150654	0.20600	0.717	0.1010	-6.020	0.75300	0.000000	137.936	0.0605	1	0	0.7340	7	68
170650	2020	211280	0.10100	0.634	0.2580	-2.226	0.85800	0.000009	91.688	0.0809	0	0	0.6370	4	76
170651	2020	337147	0.00998	0.671	0.6430	-7.161	0.62300	0.000008	75.055	0.3080	1	1	0.1950	2	70
170652	2020	189507	0.13200	0.856	0.1820	-4.928	0.72100	0.004710	94.991	0.1080	1	1	0.6420	7	74

Most frequently occurring

	year	duration_ms	acousticness	danceability	liveness	loudness	energy	instrumentalness	bpm	speechiness	has_lyrics	valence	voice_pitch	popularity	# duplicates
688	2020	198720	0.244	0.730	0.1360	-4.936	0.769	0.000021	181.988	0.1780	1	0.594	2	0	6
254	1940	195400	0.991	0.538	0.0935	-9.492	0.389	0.299000	104.561	0.0334	0	0.904	11	0	4
295	1940	210400	0.968	0.582	0.1180	-6.686	0.481	0.062600	78.270	0.0345	1	0.716	7	0	4
686	2020	194933	0.465	0.802	0.1170	-4.294	0.839	0.000052	94.997	0.0592	0	0.861	7	1	4
689	2020	198720	0.244	0.730	0.1360	-4.936	0.769	0.000021	181.988	0.1780	1	0.594	2	1	4
156	1930	187373	0.988	0.171	0.3550	-20.070	0.221	0.868000	77.768	0.0494	0	0.534	6	0	3
202	1940	175960	0.968	0.379	0.5760	-5.519	0.557	0.000129	84.198	0.0499	0	0.737	1	0	3
210	1940	182133	0.972	0.406	0.3280	-7.948	0.823	0.001420	129.476	0.0507	0	0.674	2	0	3
212	1940	183387	0.889	0.567	0.3330	-7.267	0.685	0.505000	92.620	0.0622	1	0.655	2	0	3
226	1940	191840	0.962	0.466	0.1250	-6.728	0.550	0.000451	117.101	0.0541	1	0.712	8	0	3

Overview

Variables

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Interactions

Correlations

Missing values

Sample

Duplicate rows

Most frequently occurring